﻿CREATE PROCEDURE [dbo].[usp_select_AlertSubscriptionsByAlertID]
@AlertID uniqueidentifier
AS

SET NOCOUNT ON;

SELECT [AlertSubscriptionID]
      ,[AlertID]
      ,[Active]
      ,[Subscriber]
      ,[IsGroup]
      ,[CustomEmail]
	  ,[UseStartAndEndTime]
      ,[StartUTCHour]
      ,[StartUTCMinute]
      ,[EndUTCHour]
      ,[EndUTCMinute]
      ,[BlackOutStartDate]
      ,[BlackOutEndDate]
      ,[LastFired]
      ,[IntervalMinutes]
      ,[InsertedBy]
      ,[ModifiedBy]
  FROM [dbo].[AlertSubscription]
WHERE
[AlertID] = @AlertID
AND [Active]= 1


SET NOCOUNT OFF;
